Dashboard 01 - Creating Scatter Chart, Map, & Line and Stacked Column charts Visualizations - Part 01 13

In this step, we will continue working on the first dashboard.  We will create Scatter Chart, Map, &  Line and Clustered Column charts




Step 1:  Create Scatter Chart for Violent & Major Crimes & Shootings by District

In Power BI Desktop, click on the page, RaleighPoliceIncidents

Click inside the pane

Visualizations

Click the Scatter Chart icon

Fields

Select the following:

A_KeyMeasures ->  .Major_CrimeRate% - Under Visualizations, drag & drop it in the Y Axis section.

A_KeyMeasures ->  .Total_Case_Numbers - Under Visualizations, drag & drop it in the Size section.

A_KeyMeasures ->  .Total_Shooting_Crimes - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .Violent_CrimeRate% - Under Visualizations, drag & drop it in the X Axis

Raleigh_Police_Incidents_NIBRS ->  District - Under Visualizations, drag & drop it in the Details section





Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Major_CrimeRate% = Major Crime Rate

.Total_Case_Numbers = Total Police Incidents

.Total_Shooting_Crimes = Total Shooting Crimes

Violent_CrimeRate% = Violent Crime Rate

District = District Name


Format tab

Under Format ->  General: X Position = 227 , Y Position = 144 , Width = 473 , Height = 409

Under Format -> X Axis -> Scale Type = Linear ->  Color = 094780 , Text Size = 10 pt , Font Family = Segoe UI , Title = ON , Style = Show Title Only , Title Color = 000000, Title Text Size = 12 pt, Font Family = DIN , Color = C8C6C4 , Stoke Width 2 , Line Style = Dotted

Under Format -> Y Axis ->  Position = Left , Scale Type = Linear ->  Color = FCB714 , Text Size = 10 pt , Font Family = Segoe UI , Title = ON , Style = Show Title Only , Title Color = 000000, Title Text Size = 13 pt, Font Family = DIN , Color = C8C6C4 , Stoke Width 2 , Line Style = Dotted

Under Format ->  Data Colors ->  click fx for Expression ->  Format by = Field Value, Based on Field = .Measure_Color

Under Format ->  Shapes ->  Size = 8 , Marker Shape = . (dot)

Under Format ->  Category ->  Set it to ON , Color = 000000, Text Size = 12 pt , Font Family = Segoe UI

Under Format -> Slider ->  Set it to ON ->  Color = 094780

Under Format -> Title ->  Set it to ON , Title Text = Violent & Major Crime Rate & Shootings by District , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666

Under Format -> Tooltip ->  Set it to ON , Type = Report Page , Text Size = 12 pt, Font Family = Segoe UI , Background Color = 000000 , Transparency = 5%




Analytics tab

Under X-Axis Constant Line 1 -> Click Add ->  Value = 0.0595 , Color = 1E5A8E , Transparency = 25% , Line Style = Dashed , Position = In Front

Under Y-Axis Constant Line 1 -> Click Add ->  Value = 0.2699, Color = FCB714 , Transparency = 25% , Line Style = Dashed , Position = In Front


Step 2 - Configure Filter(s)

Filters

Under Filters ->  District ->  Click on the down arrow ->  Filter Type = Basic Filtering, Select all and Uncheck Unclassified and UNK







Step 3:  Create Total Violent & Major Crime Rate Map


Visualizations

Click the Map icon

Fields

Select the following:

A_KeyMeasures ->  .Total_Major_Crimes - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .Total_Violent_Crimes - Under Visualizations, drag & drop it in the Size section.

Raleigh_Police_Incidents_NIBRS ->  District - Under Visualizations, drag & drop it in the Tooltips section

Raleigh_Police_Incidents_NIBRS->  Latitude_District - Under Visualizations, drag & drop it in the Latitude section.

Raleigh_Police_Incidents_NIBRS ->  Longitude _District - Under Visualizations, drag & drop it in the Longitude section.





Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Total_Major_Crimes = Total Major Crimes

.Total_Violent_Crimes = Total Violent Crimes

District = District Name

Latitude_District = Latitude

Longitude _District = Longitude




Format tab

Under Format ->  General: X Position = 227 , Y Position = 553 , Width = 473 , Height = 420

Under Format ->  Data Colors ->  click fx for Expression ->  Format by = Field Value, Based on Field = .Measure_Color

Under Format ->  Shapes ->  Size = 8 , Marker Shape = . (dot)

Under Format ->  Category ->  Set it to OFF

Under Format ->  Bubbles ->  Size = 40

Under Format -> Map Controls ->  Auto Zoom = ON , Zoom Buttons = ON

Under Format -> Title ->  Set it to ON , Title Text = Total Violent & Major Crime Rate , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 18 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666




Step 4 - Configure Filter(s) for Total Violent & Major Crime Rate

Filters

Under Filters ->  Latitude ->  Click on the down arrow ->  Filter Type = Basic Filtering, Select all and Uncheck Blank and 35.645420









When finished, save project.




Tips and Tricks for Maps in Power BI